package com.anolesoft.amljmes.test.fenguangyingdu.mapper;

import com.anolesoft.amljmes.test.fenguangyingdu.entity.FenguangYingduEmpDO;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.type.JdbcType;

/**
 * @author zhj
 * @date 2021/12/22 9:57
 */
@Mapper
public interface FenguangYingduEmpMapper {
//    @ResultMap("FabrecordResultMap")
    @Results(id = "FenguangYingduEmpResultMap", value = {
            @Result(id = true, column = "objuid", property = "objuid", jdbcType = JdbcType.VARCHAR),
            @Result(column = "eid", property = "eid", jdbcType = JdbcType.VARCHAR),
            @Result(column = "tuhao", property = "tuhao", jdbcType = JdbcType.VARCHAR),
    })
    @Select("select\n" +
            "objuid,\n" +
            "eid,\n" +
            "password2 \n" +
            "from view_fenguangyingdu_emp \n" +
            "where password2 = #{password2,jdbcType=VARCHAR}")
    FenguangYingduEmpDO selectEmpBypassword2(@Param("password2") String password2);
}
